﻿CREATE TABLE [dbo].[Post] (
    [id]             INT           IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CompanyId]      INT           NULL,
    [PostCategory]   INT           NULL,
    [PostId]         INT           CONSTRAINT [DF_Post_PostId] DEFAULT ((0)) NULL,
    [PostName]       NVARCHAR (50) NULL,
    [GradeFrom]      INT           NULL,
    [GradeTo]        INT           NULL,
    [PostWage]       NUMERIC (18)  CONSTRAINT [DF_Post_PostWage] DEFAULT ((0)) NULL,
    [JxWage]         NUMERIC (18)  CONSTRAINT [DF_Post_JxWage] DEFAULT ((0)) NULL,
    [TiCheng]        INT           NULL,
    [MTiCheng]       INT           NULL,
    [YjBonus]        INT           NULL,
    [Bonus]          NUMERIC (18)  CONSTRAINT [DF_Post_Bonus] DEFAULT ((0)) NULL,
    [Allowance]      INT           NULL,
    [ManQin]         NUMERIC (18)  CONSTRAINT [DF_Post_ManQin] DEFAULT ((0)) NULL,
    [SumWage]        NVARCHAR (50) NULL,
    [Memo]           VARCHAR (MAX) NULL,
    [UpTime]         DATETIME      CONSTRAINT [DF_Post_UpTime] DEFAULT (getdate()) NULL,
    [WageNumber]     NVARCHAR (50) NULL,
    [WageNumberName] NVARCHAR (50) NULL,
    CONSTRAINT [PK_Post] PRIMARY KEY CLUSTERED ([id] ASC)
);

